﻿using FreeSql.DatabaseModel;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Reflection;
using System.Threading.Tasks;
using Newtonsoft.Json;
using FreeSql.DataAnnotations;

namespace PropertyManagementSystemAPI.Models
{

    [JsonObject(MemberSerialization.OptIn), Table(Name = "systeminfo", DisableSyncStructure = true)]
    public partial class Systeminfo
    {

        /// <summary>
        /// 用户编号  主键
        /// </summary>
        [JsonProperty, Column(Name = "sysid", DbType = "int", IsPrimary = true, IsIdentity = true)]
        public int Sysid { get; set; }

        /// <summary>
        /// 出生日期
        /// </summary>
        [JsonProperty, Column(Name = "birthday", DbType = "datetime")]
        public DateTime? Birthday { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [JsonProperty, Column(Name = "createtime", DbType = "datetime")]
        public DateTime? Createtime { get; set; }

        /// <summary>
        /// 是否删除
        /// </summary>
        [JsonProperty, Column(Name = "isdelete")]
        public bool Isdelete { get; set; }

        /// <summary>
        /// 角色id  外键
        /// </summary>
        [JsonProperty, Column(Name = "roleid", DbType = "int")]
        public int? Roleid { get; set; }

        /// <summary>
        /// 身份证号码
        /// </summary>
        [JsonProperty, Column(Name = "sysidcard", DbType = "char(18)")]
        public string Sysidcard { get; set; }

        /// <summary>
        /// 用户照片
        /// </summary>
        [JsonProperty, Column(Name = "sysimg")]
        public string Sysimg { get; set; }

        /// <summary>
        /// 用户名
        /// </summary>
        [JsonProperty, Column(Name = "sysname", StringLength = 50)]
        public string Sysname { get; set; }

        /// <summary>
        /// 用户登录密码
        /// </summary>
        [JsonProperty, Column(Name = "syspassword", StringLength = 50)]
        public string Syspassword { get; set; }

        /// <summary>
        /// 用户姓名
        /// </summary>
        [JsonProperty, Column(Name = "sysrealname", StringLength = 50)]
        public string Sysrealname { get; set; }

        /// <summary>
        /// 性别
        /// </summary>
        [JsonProperty, Column(Name = "syssex", DbType = "char(2)")]
        public string Syssex { get; set; }

        /// <summary>
        /// 用户状态 （0 可用 1禁用）
        /// </summary>
        [JsonProperty, Column(Name = "sysstate")]
        public bool? Sysstate { get; set; }

        /// <summary>
        /// 联系电话
        /// </summary>
        [JsonProperty, Column(Name = "telephone", DbType = "char(11)")]
        public string Telephone { get; set; }

    }

}
